<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">
    <changeSet id="2024-02-18-create-foreign-key-for-users_authority" author="ShirayevAleksey">
        <addForeignKeyConstraint baseColumnNames="user_id"
            baseTableName="users_authority"
            constraintName="fk-user-id-for-users_authority"
            referencedColumnNames="id"
            referencedTableName="users"/>
        <addForeignKeyConstraint
                baseTableName="users_authority"
                baseColumnNames="authority_id"
                constraintName="fk-authority_id-for-users_authority"
                referencedTableName="authority"
                referencedColumnNames="id"/>
    </changeSet>
</databaseChangeLog>